Hệ thống quản lý bộ lập lịch nâng cao trong c#

6.108 lượt xem;
1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="schedule_dbDataSet" targetNamespace="http://tempuri.org/schedule_dbDataSet.xsd" xmlns:mstns="http://tempuri.org/schedule_dbDataSet.xsd" xmlns="http://tempuri.org/schedule_dbDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3   <xs:annotation>
4     <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
5       <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6         <Connections>
7           <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="schedule_dbConn" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="schedule_dbConn (MySettings)" PropertyReference="ApplicationSettings.Daily_Schedule_System.My.MySettings.GlobalReference.Default.schedule_dbConn" Provider="System.Data.OleDb" />
8         </Connections>
9         <Tables>
10           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblEventTableAdapter" GeneratorDataComponentClassName="tblEventTableAdapter" Name="tblEvent" UserDataComponentName="tblEventTableAdapter">
11             <MainSource>
12               <DbSource ConnectionRef="schedule_dbConn (MySettings)" DbObjectName="tblEvent" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13                 <DeleteCommand>
14                   <DbCommand CommandType="Text" ModifiedByUser="false">
15                     <CommandText>DELETE FROM `tblEvent` WHERE (((? = 1 AND `ID` IS NULL) OR (`ID` = ?)) AND (`Subject` = ?) AND ((? = 1 AND `Date` IS NULL) OR (`Date` = ?)) AND ((? = 1 AND `Time` IS NULL) OR (`Time` = ?)))</CommandText>
16                     <Parameters>
17                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="true" SourceVersion="Original" />
18                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
19                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Subject" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Subject" SourceColumnNullMapping="false" SourceVersion="Original" />
20                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="true" SourceVersion="Original" />
21                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Date" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Original" />
22                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Time" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="true" SourceVersion="Original" />
23                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Time" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="false" SourceVersion="Original" />
24                     </Parameters>
25                   </DbCommand>
26                 </DeleteCommand>
27                 <InsertCommand>
28                   <DbCommand CommandType="Text" ModifiedByUser="false">
29                     <CommandText>INSERT INTO `tblEvent` (`ID`, `Subject`, `Note`, `Date`, `Time`) VALUES (?, ?, ?, ?, ?)</CommandText>
30                     <Parameters>
31                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
32                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Subject" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Subject" SourceColumnNullMapping="false" SourceVersion="Current" />
33                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Note" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
34                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Date" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
35                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Time" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="false" SourceVersion="Current" />
36                     </Parameters>
37                   </DbCommand>
38                 </InsertCommand>
39                 <SelectCommand>
40                   <DbCommand CommandType="Text" ModifiedByUser="false">
41                     <CommandText>SELECT ID, Subject, [Note], [Date], [Time] FROM tblEvent</CommandText>
42                     <Parameters />
43                   </DbCommand>
44                 </SelectCommand>
45                 <UpdateCommand>
46                   <DbCommand CommandType="Text" ModifiedByUser="false">
47                     <CommandText>UPDATE `tblEvent` SET `ID` = ?, `Subject` = ?, `Note` = ?, `Date` = ?, `Time` = ? WHERE (((? = 1 AND `ID` IS NULL) OR (`ID` = ?)) AND (`Subject` = ?) AND ((? = 1 AND `Date` IS NULL) OR (`Date` = ?)) AND ((? = 1 AND `Time` IS NULL) OR (`Time` = ?)))</CommandText>
48                     <Parameters>
49                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
50                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Subject" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Subject" SourceColumnNullMapping="false" SourceVersion="Current" />
51                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Note" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
52                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Date" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
53                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Time" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="false" SourceVersion="Current" />
54                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="true" SourceVersion="Original" />
55                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
56                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Subject" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Subject" SourceColumnNullMapping="false" SourceVersion="Original" />
57                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="true" SourceVersion="Original" />
58                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Date" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Original" />
59                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Time" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="true" SourceVersion="Original" />
60                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Time" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="false" SourceVersion="Original" />
61                     </Parameters>
62                   </DbCommand>
63                 </UpdateCommand>
64               </DbSource>
65             </MainSource>
66             <Mappings>
67               <Mapping SourceColumn="ID" DataSetColumn="ID" />
68               <Mapping SourceColumn="Subject" DataSetColumn="Subject" />
69               <Mapping SourceColumn="Note" DataSetColumn="Note" />
70               <Mapping SourceColumn="Date" DataSetColumn="Date" />
71               <Mapping SourceColumn="Time" DataSetColumn="Time" />
72             </Mappings>
73             <Sources />
74           </TableAdapter>
75         </Tables>
76         <Sources />
77       </DataSource>
78     </xs:appinfo>
79   </xs:annotation>
80   <xs:element name="schedule_dbDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="schedule_dbDataSet" msprop:Generator_UserDSName="schedule_dbDataSet">
81     <xs:complexType>
82       <xs:choice minOccurs="0" maxOccurs="unbounded">
83         <xs:element name="tblEvent" msprop:Generator_TableClassName="tblEventDataTable" msprop:Generator_TableVarName="tabletblEvent" msprop:Generator_TablePropName="tblEvent" msprop:Generator_RowDeletingName="tblEventRowDeleting" msprop:Generator_UserTableName="tblEvent" msprop:Generator_RowChangingName="tblEventRowChanging" msprop:Generator_RowEvHandlerName="tblEventRowChangeEventHandler" msprop:Generator_RowDeletedName="tblEventRowDeleted" msprop:Generator_RowEvArgName="tblEventRowChangeEvent" msprop:Generator_RowChangedName="tblEventRowChanged" msprop:Generator_RowClassName="tblEventRow">
84           <xs:complexType>
85             <xs:sequence>
86               <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" minOccurs="0">
87                 <xs:simpleType>
88                   <xs:restriction base="xs:string">
89                     <xs:maxLength value="255" />
90                   </xs:restriction>
91                 </xs:simpleType>
92               </xs:element>
93               <xs:element name="Subject" msprop:Generator_ColumnVarNameInTable="columnSubject" msprop:Generator_ColumnPropNameInRow="Subject" msprop:Generator_ColumnPropNameInTable="SubjectColumn" msprop:Generator_UserColumnName="Subject">
94                 <xs:simpleType>
95                   <xs:restriction base="xs:string">
96                     <xs:maxLength value="255" />
97                   </xs:restriction>
98                 </xs:simpleType>
99               </xs:element>
100               <xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note" minOccurs="0">
101                 <xs:simpleType>
102                   <xs:restriction base="xs:string">
103                     <xs:maxLength value="536870910" />
104                   </xs:restriction>
105                 </xs:simpleType>
106               </xs:element>
107               <xs:element name="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInRow="_Date" msprop:Generator_ColumnPropNameInTable="DateColumn" msprop:Generator_UserColumnName="Date" minOccurs="0">
108                 <xs:simpleType>
109                   <xs:restriction base="xs:string">
110                     <xs:maxLength value="255" />
111                   </xs:restriction>
112                 </xs:simpleType>
113               </xs:element>
114               <xs:element name="Time" msprop:Generator_ColumnVarNameInTable="columnTime" msprop:Generator_ColumnPropNameInRow="Time" msprop:Generator_ColumnPropNameInTable="TimeColumn" msprop:Generator_UserColumnName="Time" minOccurs="0">
115                 <xs:simpleType>
116                   <xs:restriction base="xs:string">
117                     <xs:maxLength value="255" />
118                   </xs:restriction>
119                 </xs:simpleType>
120               </xs:element>
121             </xs:sequence>
122           </xs:complexType>
123         </xs:element>
124       </xs:choice>
125     </xs:complexType>
126     <xs:unique name="Constraint1" msdata:PrimaryKey="true">
127       <xs:selector xpath=".//mstns:tblEvent" />
128       <xs:field xpath="mstns:Subject" />
129     </xs:unique>
130   </xs:element>
131 </xs:schema>


Web, Tìm kết quả nhanh

Kích thước hoặc độ phức tạp của bản gửi này, tác giả đã gửi nó dưới dạng tệp .zip để rút ngắn thời gian tải xuống của bạn. Sau khi tải xuống, bạn sẽ cần một chương trình như Winzip để giải nén nó.

Tất cả các tệp đều được codefly.vn quét mỗi ngày một lần để tìm vi-rút, nhưng vi-rút mới xuất hiện hàng ngày nên không có chương trình phòng ngừa nào có thể bắt được 100% chúng.

ĐỂ AN TOÀN CỦA CHÍNH BẠN, VUI LÒNG:

1. Quét lại các tệp đã tải xuống bằng trình kiểm tra vi-rút cá nhân của bạn trước khi sử dụng.

2. KHÔNG BAO GIỜ, chạy các tệp đã biên dịch (.exe's, .ocx's, .dll's, v.v.)--chỉ chạy code mà bạn đã xem ít nhất 1 lần.

Official Website:

https://www.techprofree.com/.....c-with-source-code/

Gõ tìm kiếm nhanh...



Dự án liên quan!

Cách tạo đồng hồ bấm giờ trong C#

72 lượt xem

Hệ thống quản lý hàng tồn kho sử dụng cơ sở dữ liệu VB.NET và MySQL với mã nguồn

71 lượt xem

Đếm nguyên âm và phụ âm

117 lượt xem

Phần mềm quản lý nhân viên hiện đại sử dụng C#.net và Bunifu Framework với Full Source Code (2020)

181 lượt xem

Hệ thống quản lý đại học bằng C# với mã nguồn đầy đủ

145 lượt xem

Hệ thống quản lý bệnh viện bằng C# với mã nguồn đầy đủ

159 lượt xem